|
47
|
How can I prevent grouping by a specified column
public void init()
{
COM com_Column;
anytype var_Column;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_Column = COM::createFromObject(expivot1.DataColumns()).Item("Freight"); com_Column = var_Column;
com_Column.AllowGroupBy(0/*exGroupByNone*/);
}
|
|
46
|
How can I sort alphabetically the columns to be displayed in the context menu/floating panel
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotBarVisible(69595/*exPivotBarContextSortAscending | exPivotBarAllowResizeColumns | exPivotBarAllowUndoRedo | exPivotBarAutoUpdate | exPivotBarAllowFormatContent | exPivotBarAllowFormatAppearance | exPivotBarAllowValues | exPivotBarShowTotals | exPivotBarAutoFit | exPivotBarSizable | exPivotBarVisible*/);
expivot1.PivotColumnsSortOrder(1/*exPivotColumnsAscending*/);
expivot1.PivotColumnsFloatBarVisible(true);
}
|
|
45
|
How can I prevent dropping data to the control
public void init()
{
;
super();
expivot1.AllowDrop(false);
}
|
|
44
|
Is it possible to allow incremental filtering on drop down filter window too, as I can on the control menus
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0");
expivot1.DisplayFilterList(42272/*exHideFilterPattern | exFilterListDefault*/);
}
|
|
43
|
How can I prevent showing the Filter For field in the drop down filter window
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0");
expivot1.DisplayFilterList(42272/*exHideFilterPattern | exFilterListDefault*/);
}
|
|
42
|
How can I display the numeric columns only when selecting a new aggregate, like SUM
public void init()
{
COM com_Column;
anytype var_Column;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0[bold]");
expivot1.PivotColumns("sum(5)/12,count(5)/12");
var_Column = COM::createFromObject(expivot1.DataColumns()).Item("Freight"); com_Column = var_Column;
com_Column.SortType(1/*SortNumeric*/);
}
|
|
41
|
How can I add a value column
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0");
expivot1.PivotColumns("sum(5)/12");
}
|
|
40
|
I would like to always have the subtotals in the same row of the "father row". Could that be done
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0[bold],2");
expivot1.PivotColumns("sum(5)/12,count(5)/12");
expivot1.ShowViewCompact(35/*exViewCompactAggregates | exViewCompact*/);
expivot1.PivotTotals("/sum,sum(0)");
}
|
|
39
|
Is there any way, when I change the filter of the column, it broadcast the filter to the other pivot columns that were duplicated
public void init()
{
str var_s;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0,2");
expivot1.ShowBranchRows(2/*exBranchCompact*/);
var_s = "sum(5)/12[filter='gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZrMJnMoAgI='],count(5)/12[filter='gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZr";
var_s = var_s + "MJnMoAgI=']";
expivot1.PivotColumns(var_s);
expivot1.ShowViewCompact(19/*exViewCompactKeepSettings | exViewCompact*/);
}
|
|
38
|
How can I summarize more fields in the same cell
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0,2");
expivot1.ShowBranchRows(2/*exBranchCompact*/);
expivot1.PivotColumns("sum(5)/12,count(5)/12");
expivot1.ShowViewCompact(3/*exViewCompact*/);
}
|
|
37
|
How do I programmatically group by rows, in a compact way, no hierarchy lines
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0,2");
expivot1.ShowBranchRows(2/*exBranchCompact*/);
}
|
|
36
|
How do I programmatically group by rows
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0,1,2");
expivot1.LinesAtRoot(-1/*exLinesAtRoot*/);
expivot1.HasLines(1/*exSolidLine*/);
}
|
|
35
|
How do I programmatically group by columns
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0");
expivot1.PivotColumns("sum(5)/12;6");
}
|
|
34
|
How can I hide the add new button on the pivot bar
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotBarVisible(8155/*exPivotBarHideAddNew | exPivotBarAllowResizeColumns | exPivotBarAllowUndoRedo | exPivotBarAutoUpdate | exPivotBarAllowFormatContent | exPivotBarAllowFormatAppearance | exPivotBarAllowValues | exPivotBarShowTotals | exPivotBarAutoFit | exPivotBarSizable | exPivotBarVisible*/);
}
|
|
33
|
Is it possible to show the data that generated the result, when double clicking the row
public void init()
{
;
super();
expivot1.BeginUpdate();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0[italic]");
expivot1.PivotColumns("count(0)[underline]");
expivot1.PivotTotals("count[bold,strikeout]");
expivot1.ShowDataOnDblClick(true);
expivot1.EndUpdate();
}
|
|
32
|
Does your control support subscript or superscript, in HTML captions
public void init()
{
COM com_Column;
anytype var_Column;
;
super();
expivot1.HeaderHeight(22);
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_Column = COM::createFromObject(expivot1.DataColumns()).Item("ShipCountry"); com_Column = var_Column;
com_Column.Caption("ShipCountry<font ;7><off 6><sha ;;0>subscript");
var_Column = COM::createFromObject(expivot1.DataColumns()).Item("ShipRegion"); com_Column = var_Column;
com_Column.Caption("ShipRegion<font ;7><off -6><sha ;;0>superscript");
expivot1.Refresh();
}
|
|
31
|
Is it possible to define a different background color for the pivot bar
public void init()
{
;
super();
expivot1.Background(97/*exPivotBarBackColor*/,WinApi::RGB2int(240,240,240));
}
|
|
30
|
How can I display an icon/image to Content sub-menu
public void init()
{
COM com_FormatContent;
anytype var_FormatContent;
str var_s;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql";
var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0";
var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN";
var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=";
expivot1.Images(COMVariant::createFromStr(var_s));
var_FormatContent = COM::createFromObject(expivot1.FormatContents()).Item("numeric"); com_FormatContent = var_FormatContent;
com_FormatContent.Name("<img>1</img> Numeric");
expivot1.PivotRows("5[content=numeric]");
}
|
|
29
|
How can I change the selection background in the control's context menu
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.Background(20/*exSelBackColorFilter*/,WinApi::RGB2int(255,0,0));
}
|
|
28
|
How can I display the column as date in a long format
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.FormatContents().Add("longdate","longdate(date(value))");
expivot1.PivotRows("9[content=longdate]");
}
|
|
27
|
Is it possible to display the column in upper-case
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.FormatContents().Add("upper","upper(value)");
expivot1.PivotRows("0[content=upper]");
}
|
|
26
|
How can I programatically bold a column
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0[bold]");
}
|
|
25
|
How can I display the total with a different foreground color
public void init()
{
COM com_FormatAppearance;
anytype var_FormatAppearance;
;
super();
var_FormatAppearance = COM::createFromObject(expivot1.FormatAppearances()).Add("fore"); com_FormatAppearance = var_FormatAppearance;
com_FormatAppearance.ForeColor(WinApi::RGB2int(255,0,0));
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0");
expivot1.PivotColumns("sum(5)");
expivot1.PivotTotals("sum[fore,bold]");
}
|
|
24
|
How can I display the total with a different background color/ebn
public void init()
{
COM com_FormatAppearance;
anytype var_FormatAppearance;
;
super();
expivot1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
var_FormatAppearance = COM::createFromObject(expivot1.FormatAppearances()).Add("back"); com_FormatAppearance = var_FormatAppearance;
com_FormatAppearance.BackColor(0x1000000);
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0");
expivot1.PivotColumns("sum(5)");
expivot1.PivotTotals("sum[back]");
}
|
|
23
|
How can I display the total with a solid background color
public void init()
{
COM com_FormatAppearance;
anytype var_FormatAppearance;
;
super();
var_FormatAppearance = COM::createFromObject(expivot1.FormatAppearances()).Add("back"); com_FormatAppearance = var_FormatAppearance;
com_FormatAppearance.BackColor(WinApi::RGB2int(240,240,240));
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0");
expivot1.PivotColumns("sum(5)");
expivot1.PivotTotals("sum[back]");
}
|
|
22
|
Is it possible to change the "bold" caption in the control's context menu
public void init()
{
COM com_FormatAppearance;
anytype var_FormatAppearance;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_FormatAppearance = COM::createFromObject(expivot1.FormatAppearances()).Item("bold"); com_FormatAppearance = var_FormatAppearance;
com_FormatAppearance.Name("Ingrosat");
}
|
|
21
|
Is it possible to show no Exclude field in the filter window
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.DisplayFilterList(288/*exShowCheckBox | exSortItemsAsc*/);
}
|
|
20
|
How can I prevent showing the drop down filter button
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.DisplayFilterList(2/*exNoItems*/);
}
|
|
19
|
How do I get the count of positive values only
public void init()
{
COM com_Aggregate;
anytype var_Aggregate;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_Aggregate = COM::createFromObject(expivot1.Aggregates()).Add("positive","sum"); com_Aggregate = var_Aggregate;
com_Aggregate.FormatValue("value < 0 ? 0 : 1");
expivot1.PivotRows("0");
expivot1.PivotColumns("positive(5)");
}
|
|
18
|
How do I get the sum for negative values only
public void init()
{
COM com_Aggregate;
anytype var_Aggregate;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_Aggregate = COM::createFromObject(expivot1.Aggregates()).Add("negative","sum"); com_Aggregate = var_Aggregate;
com_Aggregate.FormatValue("value < 0 ? value : 0");
expivot1.PivotRows("0");
expivot1.PivotColumns("negative(5)");
}
|
|
17
|
My data stores the data as strings, is it possible to load the data using Import method
public void init()
{
;
super();
expivot1.Import("'string 1';'string 2'#'string 3';'string 4'","str=`'` eor='#' eof=';' hdr=0");
}
|
|
16
|
Is it possible to load data using different separators
public void init()
{
;
super();
expivot1.Import("item 1;item 2#item 3;item 4","eor='#' eof=';' hdr=0");
}
|
|
15
|
Is it possible to align a column
public void init()
{
COM com_Column;
anytype var_Column;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_Column = COM::createFromObject(expivot1.DataColumns()).Item(COMVariant::createFromInt(0)); com_Column = var_Column;
com_Column.Alignment(2/*RightAlignment*/);
com_Column.HeaderAlignment(2/*RightAlignment*/);
expivot1.Refresh();
}
|
|
14
|
How can I change by code the column/rows background color
public void init()
{
COM com_FormatAppearance;
anytype var_FormatAppearance;
;
super();
expivot1.BeginUpdate();
expivot1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_FormatAppearance = COM::createFromObject(expivot1.FormatAppearances()).Add("aka"); com_FormatAppearance = var_FormatAppearance;
com_FormatAppearance.BackColor(0x1000000);
expivot1.PivotRows("0[aka]");
expivot1.EndUpdate();
}
|
|
13
|
How can I apply by code any appearance to my list
public void init()
{
;
super();
expivot1.BeginUpdate();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0[italic]");
expivot1.PivotColumns("count(0)[underline]");
expivot1.PivotTotals("count[bold,strikeout]");
expivot1.EndUpdate();
}
|
|
12
|
How can I display an icon instead SUM/Total field
public void init()
{
COM com_Aggregate;
anytype var_Aggregate;
str var_s;
;
super();
expivot1.BeginUpdate();
var_s = "gBJJgBggAAwAAgACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjIgjIBAEijUlk8plUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql";
var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9oEEwGBwWDwmFw2Hw9+xUsxGNx2Px+LyUnyGVy2VyeZAGNjIJjITjIb0OjjGi0ukAAVj";
var_s = var_s + "ILzmayWtAGejCvjLh2u3jG23O4ACx1ew11+zEYGsZZsZUe/wkZ4sYZvD4PCy8kjAzjLFjKd5WDjIz6HRvnTwUZGMZX8ZTPb8XU8Hh9cFjALjKVjK5jIv9/w9t78WdjJI";
var_s = var_s + "oyWr7sKjIWu+/a8Og2QAEajLaIxAzlwhB0DwQuzoECjJWw1DiMQ3D0OgAQMKwsuj8xOy0SrzFEWMdFUExbGMCRfC8ZRswMaLsiofJVHiOo+kKRs2lL2Jsh8cyQo6Ag==";
expivot1.Images(COMVariant::createFromStr(var_s));
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_Aggregate = COM::createFromObject(expivot1.Aggregates()).Item("sum"); com_Aggregate = var_Aggregate;
com_Aggregate.Name("<img>1</img> Sum");
com_Aggregate.Caption("<img>1</img>");
expivot1.PivotColumnsFloatBarVisible(true);
expivot1.FormatPivotHeader("iaggregate ? (caggregate + (iaggregate != 5 ? ' ' : '') + caption) : caption");
expivot1.FormatPivotTotal("caggregate");
expivot1.PivotRows("0");
expivot1.PivotColumns("sum(5)");
expivot1.PivotTotals("sum,count");
expivot1.EndUpdate();
}
|
|
11
|
How can I change the caption to be displayed when dragging an aggregate function
public void init()
{
;
super();
expivot1.BeginUpdate();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotColumnsFloatBarVisible(true);
expivot1.FormatPivotHeader("(iaggregate ? ('<b>' + upper(caggregate) + '</b> of ' + caption) : caption)");
expivot1.PivotRows("0");
expivot1.PivotColumns("sum(5)");
expivot1.PivotTotals("sum,count");
expivot1.EndUpdate();
}
|
|
10
|
I am using Import method, just wondering if I can rename the columns
public void init()
{
COM com_Column;
anytype var_Column;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
var_Column = COM::createFromObject(expivot1.DataColumns()).Item(COMVariant::createFromInt(0)); com_Column = var_Column;
com_Column.Caption("New Caption");
com_Column.PivotCaption("New Pivot Caption");
expivot1.Refresh();
}
|
|
9
|
Does your control support Fit-To-Page Print and Print Preview
public void init()
{
COM com_Print;
anytype var_Print;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0,1,2");
expivot1.ExpandAll();
// Add 'exprint.dll(ExPrint.dll)' reference to your project.
// Add 'ExPrint 1.0 Control Library(ExPrint.dll)' reference to your project.
var_Print = COM::createFromObject(new EXPRINTLib.exprint()); com_Print = var_Print;
com_Print.Options("FitToPage = On");
com_Print.PrintExts(COM::createFromVariant(expivot1));
com_Print.Preview();
}
|
|
8
|
How can I print the control
public void init()
{
COM com_Print;
anytype var_Print;
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0,1,2");
expivot1.ExpandAll();
// Add 'exprint.dll(ExPrint.dll)' reference to your project.
// Add 'ExPrint 1.0 Control Library(ExPrint.dll)' reference to your project.
var_Print = COM::createFromObject(new EXPRINTLib.exprint()); com_Print = var_Print;
com_Print.PrintExts(COM::createFromVariant(expivot1));
com_Print.Preview();
}
|
|
7
|
How can I hide the pivot bar (hide completly)
public void init()
{
;
super();
expivot1.PivotBarVisible(4058/*exPivotBarAllowResizeColumns | exPivotBarAllowUndoRedo | exPivotBarAutoUpdate | exPivotBarAllowFormatContent | exPivotBarAllowFormatAppearance | exPivotBarAllowValues | exPivotBarShowTotals | exPivotBarAutoFit | exPivotBarSizable*/);
}
|
|
6
|
How can I hide the pivot bar (auto-hide)
public void init()
{
;
super();
expivot1.PivotBarVisible(4083/*exPivotBarAllowResizeColumns | exPivotBarAllowUndoRedo | exPivotBarAutoUpdate | exPivotBarAllowFormatContent | exPivotBarAllowFormatAppearance | exPivotBarAllowValues | exPivotBarAutoHide | exPivotBarShowTotals | exPivotBarSizable | exPivotBarVisible*/);
}
|
|
5
|
How can I count and get the total of a specified column
public void init()
{
;
super();
expivot1.BeginUpdate();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotColumnsFloatBarVisible(true);
expivot1.PivotRows("0");
expivot1.PivotColumns("sum(5)");
expivot1.PivotTotals("sum,count");
expivot1.EndUpdate();
}
|
|
4
|
How can I add show the columns once I grouped a column
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0");
expivot1.PivotColumnsFloatBarVisible(true);
}
|
|
3
|
How can I programatically group the columns
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
expivot1.PivotRows("0:D");
}
|
|
2
|
Is it possible to load data from a data source
public void init()
{
COM com_rs;
anytype rs;
;
super();
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
rs = COM::createFromObject(new ADODB.Recordset()); com_rs = rs;
rs.Open("Data","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExPivot\\Sample\\Access\\sample.accdb",3/*adOpenStatic*/,3/*adLockOptimistic*/);
expivot1.DataSource(rs);
}
|
|
1
|
How can I load data
public void init()
{
;
super();
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
}
|